Skip to main content

DataStax

Samples Overview​

Qarbine provides a wide variety of sample templates, and queries. Some are application oriented examples, while others are database administrator (DBA) oriented.

Below are a few of the component samples to consider. Review the Qarbine Catalog for the latest components. See the latest set of DataStax components in the folder depicted below.

  

  

Schemas​

This general purpose template is at “Qarbine_admin/Cached schemas for prompted data service”. It displays information on all of the cached schemas. These schemas are saved as users interact with data tools such as the Data Source Designer, Query by Example, and Report by Example. If a particular collection is not shown in the output, simply open one of these tools and select it from the collection drop down to create it. Then rerun the template.

Running the template prompts for a data service.

  

Below are sample snippets from running the template.

    

List Databases​

This template is at “example/DataStax/DBA/List databases”. It provides basic name information on the DataStax databases within the configured environment. Below is a sample snippet from running the template.

  

It uses the Qarbine virtual query “list databases”.

Describe Databases​

This template is at “example/DataStax/DBA/Describe databases”. It provides detailed information on the DataStax databases within the configured environment. Below is a sample snippet from running the template.

  

  

It uses the Qarbine virtual query “describe databases”.

List Keyspaces​

This template is at “example/DataStax/DBA/List keyspaces”. It provides information on the DataStax keyspaces within the configured environment. Below is a sample snippet from running the template.

  

It uses the Qarbine virtual query “list keyspaces”.

List Collections​

This template is at “example/DataStax/DBA/List collections”. It provides basic name information on the DataStax collections within the configured environment. Below is a sample snippet from running the template.

  

It uses the Qarbine virtual query “list collections”.

Describe Collections​

This template is at “example/DataStax/DBA/Describe collections”. It provides information on the DataStax collections within the configured environment. Below is a sample snippet from running the template.

  

It uses the Qarbine virtual query “describe collections”

Describe a Collection​

This template is at “example/DataStax/DBA/Describe @collection”. It provides information on a chosen DataStax collection within the configured environment. When run it presents a selection prompt as shown below.

  

Choose a collection and then click

  

The result is shown below.

  

It uses the Qarbine virtual query “describe collection COLLECTION”.

Tally Collections Documents​

This template is at “example/DataStax/DBA/Tally collections”. It provides information on the estimated document counts of the DataStax collections within the configured environment. Below is a sample snippet from running the template.

  

It uses the Qarbine virtual query “tally collections”.

Tally Collection Documents​

This template is at “example/DataStax/DBA/Tally @collection”. It provides estimate document count information on the chosen DataStax collection within the configured environment. When run it presents a selection prompt as shown below.

  

Choose a collection and then click

  

The result is shown below.

  

It uses the Qarbine virtual query “tally collection COLLECTION”.